Comment by nine_k

SELECT FOR UPDATE was invented to address this,