UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qEyv80Rq/YdjPjr/li/KAre4esAWWRYSl3eHuK9s1+M='
WHERE
key_id = 'a29af22cda25807baaf4848919a761b88ec5a9cc470fa2f0193bf47cfda5c4f4'
AND (
token = 'qEyv80Rq/YdjPjr/li/KAre4esAWWRYSl3eHuK9s1+M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)