UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KnUDtF0+zU4wCHC+AiWgxd3pop7SHWyS3t3CA7WVBE0='
WHERE
key_id = 'a9ebc0f13883fa41bc783b0797a0e658ba87cc0355a9dc4f1b755adb845e9677'
AND (
token = 'KnUDtF0+zU4wCHC+AiWgxd3pop7SHWyS3t3CA7WVBE0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)