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