START TRANSACTION;
UPDATE savings_accounts
SET balance = balance - 500
WHERE account = 3209;

UPDATE checking_accounts
SET balance = balance + 500
WHERE account = 3208;

COMMIT;