UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U7Dp/VvuhMZaCb7pI5ujTIP6MVgze74YE3Ju7gVreiM='
WHERE
key_id = '00c7bb521cc00032319133c584bb9aa5364cc1be32904b436e53f235def0e80d'
AND (
token = 'U7Dp/VvuhMZaCb7pI5ujTIP6MVgze74YE3Ju7gVreiM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)