UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8I1A0YEPvhw6b95hi2LSLz3mR6CqanMkMuEDfHB6eU4='
WHERE
key_id = '7538a78b1910fe1aa3ab26b84ec30a9528c87f0c400d93960fd3e630c5ac37ec'
AND (
token = '8I1A0YEPvhw6b95hi2LSLz3mR6CqanMkMuEDfHB6eU4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)