UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZgTDLF5looikuyFK+EOQlLDXCjNRLTeUUnmz+ZGZpV4='
WHERE
key_id = 'a9aa032f677cfae12d7b552348d2acef7ca19d61a2d240daf6e6c226a830acdd'
AND (
token = 'ZgTDLF5looikuyFK+EOQlLDXCjNRLTeUUnmz+ZGZpV4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)