UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CzMRfgg315J0EVEdFqax2RIRsSsps6YIQug4nWFtEwM='
WHERE
key_id = 'b11eb8ce1d59e3c6788dcc9bc7461d456fde04fa69a6fc5458756eca68c0fbfc'
AND (
token = 'CzMRfgg315J0EVEdFqax2RIRsSsps6YIQug4nWFtEwM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)