UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2kPQDWJcm8Oq55zjf9YlHdWGTqP3qPp4c24kjtB7cec='
WHERE
key_id = '0e8f2d3be818573ec194419e6e320f59add51adcd38e7a80caf3d6994c1f81e5'
AND (
token = '2kPQDWJcm8Oq55zjf9YlHdWGTqP3qPp4c24kjtB7cec='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)