UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JB7JDsOc82SeKCkNH7Yxn073UuC6VjmmOedfxGYd0dw='
WHERE
key_id = 'ccdd22630493c90de522dfc23afbab6f0ebf08ec24405dc62f9ceb3916e9c2ad'
AND (
token = 'JB7JDsOc82SeKCkNH7Yxn073UuC6VjmmOedfxGYd0dw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)