Claim a queue row without two workers taking it

START TRANSACTION;
SELECT id, payload FROM jobs
  WHERE reserved_at IS NULL ORDER BY id LIMIT 1
  FOR UPDATE SKIP LOCKED;
UPDATE jobs SET reserved_at = NOW() WHERE id = ?;
COMMIT;