UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a16qZjmBMNXVg1YZseRe3B4/1xtR7j8qNnSf8pbKVVo='
WHERE
key_id = '409ea337c124799e5034f0fb6328025ddb5c9daa1587ada92de9eb286dabd1ef'
AND (
token = 'a16qZjmBMNXVg1YZseRe3B4/1xtR7j8qNnSf8pbKVVo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)