UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UKfmIibPWfRLMilkS9mgM9R5tSq5jWT2xXEAf1rvlBc='
WHERE
key_id = '76cb598f67dfdb0412461a97d555ba47e97341c592a3b920ac1d2a72239852aa'
AND (
token = 'UKfmIibPWfRLMilkS9mgM9R5tSq5jWT2xXEAf1rvlBc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)