UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Y0ujUPHgdSexTbgr6FMsf3u+X28ou+jlSCJHUuzy1nU='
WHERE
key_id = 'a7c9131b7997e5f1be2e2a57c63c72b42dfeac4ec3f0c3abf7b7cf0ea2ed7885'
AND (
token = 'Y0ujUPHgdSexTbgr6FMsf3u+X28ou+jlSCJHUuzy1nU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)