Preventing database race/ghosting conditions with CF?

I'm not sure what the correct term is, but I am curious how to prevent over writing a table before a script is done with calculations and input.

For instance, say I deduct from a clients account right as they are making a deposit. Thus nullifiying the deposit they just made because my entry over wrote it will old data.

Is there a way to lock a particular mysql table to a coldfusion request until the request is complete?