UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+6wLT69gOdFMhHKG3xYUktEGe3AT01gD6vZuav3H88k='
WHERE
key_id = '1c81a7649e91fe4c85156d6e1d470e1eff3c34f9c166fbbab376cc7979ccd144'
AND (
token = '+6wLT69gOdFMhHKG3xYUktEGe3AT01gD6vZuav3H88k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)