Credit every account in accounts by 10. Do it in one statement, not row by row in a long transaction: a short operation releases locks sooner and does not hold rows locked for long.