UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sMtPNqX01eBOwzhmsRqDGtzxkGanne93xYxPMqyPK40='
WHERE
key_id = '1bcb3875b087137f961a43420c89c12a59145629ba98e42aec20c6d57d88c1f3'
AND (
token = 'sMtPNqX01eBOwzhmsRqDGtzxkGanne93xYxPMqyPK40='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)