UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd7qKjLb0dvjqSWB7NJSYqjAiHzG3rF4awijFjtqEx/k='
WHERE
key_id = '69af1588ad96d9dd1b1e2d7863a934a398be9909d73d87fca35d57a0426f0c7a'
AND (
token = 'd7qKjLb0dvjqSWB7NJSYqjAiHzG3rF4awijFjtqEx/k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)