UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9aP0VKK1c79f27bIJfacntWVafnS1Ajm+CXBElNYvhU='
WHERE
key_id = 'e11aca9bf800abdf763b7e810dbc1c126adc059819d0113f539f4965f1799f56'
AND (
token = '9aP0VKK1c79f27bIJfacntWVafnS1Ajm+CXBElNYvhU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)