UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+R/2tzrBLNWfIVxTTMHOtl5OH07lNtOH+3rRwGcc6hg='
WHERE
key_id = 'b701fcc5de78554c5e8f14da0270782a7a75eb878b59ac07310313cb5c0ab8b4'
AND (
token = '+R/2tzrBLNWfIVxTTMHOtl5OH07lNtOH+3rRwGcc6hg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)