Race conditions absolutely are among the set of things transactions are supposed to help with and locks are one of the several ways they do it. It's the I from

Race conditions absolutely are among the set of things transactions are supposed to help with and locks are one of the several ways they do it. It's the I from ACID, which stands for Isolation. Transactions are not omnipotent in that regard and they fail in several well-researched ways, but it is in their purview.