UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sLMd3N0EASRtz5FHgpsLyn4peDnoBQovWjMAjlsIKGo='
WHERE
key_id = 'bdae20ca0a4f9c7b8633b938c6df44ba798588a23611351dfcef2b82758ea76e'
AND (
token = 'sLMd3N0EASRtz5FHgpsLyn4peDnoBQovWjMAjlsIKGo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)