UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kmYrgD9GQRWdvSVqflWxsVpTJJ5i71XRUPQdyxCtjjc='
WHERE
key_id = '7e8765841ff7ad285a9b7bfe78cde2d02a6d16115ef700d0195dc038d44ceb0a'
AND (
token = 'kmYrgD9GQRWdvSVqflWxsVpTJJ5i71XRUPQdyxCtjjc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)