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