UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FzG8VxSVxjjR7YJVrA/m18/t3pGwKkzuXY8DIfB5ojA='
WHERE
key_id = '2075895524764be029137ecbebe4e5b59cefd17057a27439edd6ca603c794c7a'
AND (
token = 'FzG8VxSVxjjR7YJVrA/m18/t3pGwKkzuXY8DIfB5ojA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)