UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'm44BBLkNqG9c88lVi6ckuTqxR8Y2aRupSke78rQgR7I='
WHERE
key_id = '1f9f74ba93d1b39337879efba4d8b5508f28a609ac6e30f3969a91c6afc06b57'
AND (
token = 'm44BBLkNqG9c88lVi6ckuTqxR8Y2aRupSke78rQgR7I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)