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