UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mv50Hfg04K8dCci1jAv17Vsl73n+b5GoB4wTW0FmkKY='
WHERE
key_id = 'a4c4c3934ab225be57d27e72da5a19f997de94be5b6c9ebfd97245c0a0dc3de4'
AND (
token = 'mv50Hfg04K8dCci1jAv17Vsl73n+b5GoB4wTW0FmkKY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)