UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CALid/bnTA4+Ebf5jMi/sHbGCtkU7GFxlfVon0ButcY='
WHERE
key_id = 'fd5d50bb1fc33400e437d0edde2571b46ee868991e913a6267d77835543feebd'
AND (
token = 'CALid/bnTA4+Ebf5jMi/sHbGCtkU7GFxlfVon0ButcY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)