UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OJTP9/Jjf8mFSA7k9SUzj3jODj0Y4bxfU3Z4UzIXOBY='
WHERE
key_id = 'a50b0462a4c8999adc91e915be2f27bb5a20c66bf18b7830746ef30a5dd270f4'
AND (
token = 'OJTP9/Jjf8mFSA7k9SUzj3jODj0Y4bxfU3Z4UzIXOBY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)