UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z8GZgr+waOD2kLQ7Opg3KiL0CkI0K+yx19lWDze2rJc='
WHERE
key_id = '9e27a049a97cc2c9d895465b03ff2dbffec7813b7350b6c312268f131286cb8f'
AND (
token = 'Z8GZgr+waOD2kLQ7Opg3KiL0CkI0K+yx19lWDze2rJc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)