UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zSdZ+mwJ3IfGVyovYinC8vt5pkSrP9MkGBncnW29Im0='
WHERE
key_id = '53c00685f82b808730a97a5403dd872a0dc52e22b83d28c0f13fdc287abebf20'
AND (
token = 'zSdZ+mwJ3IfGVyovYinC8vt5pkSrP9MkGBncnW29Im0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)