UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jYyONwPCy51jZv00a9DJ3HtPvvbd/0N64f0ScPMp8cs='
WHERE
key_id = 'b472fd0254ac45a98270b3f243e2d4229555b1ad287be7e2cf99d53926a693c1'
AND (
token = 'jYyONwPCy51jZv00a9DJ3HtPvvbd/0N64f0ScPMp8cs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)