UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lodO5dcGOzk1oL/83ZoaP+ft0qQqwOJlYAXHWW1eZbs='
WHERE
key_id = 'e2be784d91667b6d9dd2b7b35e156810a46821c96cee0b942d58a97c08ab345a'
AND (
token = 'lodO5dcGOzk1oL/83ZoaP+ft0qQqwOJlYAXHWW1eZbs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)