UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lQsi6rFc9PErRH9b8s5yv+BYbJWGnBvW6FAGl0RHQmY='
WHERE
key_id = '59d578d8d0551711f76a9c484a953f061e3b81f25b2396c2b3986fc5e3a325de'
AND (
token = 'lQsi6rFc9PErRH9b8s5yv+BYbJWGnBvW6FAGl0RHQmY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)