UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C4ld2Rz7mUA7k4uE1rGApirQ4nsRh4DNQmh3axy1Sxc='
WHERE
key_id = '9821f69ff42a937520a57aa8f4a33350a0621bb30eb3612a43998e175a59a2d7'
AND (
token = 'C4ld2Rz7mUA7k4uE1rGApirQ4nsRh4DNQmh3axy1Sxc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)