UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9WZZM8S6Fwly/o72vCFzGaphRQGHRNP+fQ8u/UHEyOA='
WHERE
key_id = '62301fa8cb266973938b5a6cb54787574bb9050df1a83190bd808541df5bfd17'
AND (
token = '9WZZM8S6Fwly/o72vCFzGaphRQGHRNP+fQ8u/UHEyOA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)