UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dD8DBBQvnQg2TQ3K292clZCAxO0OnDbVSnnApY96M/s='
WHERE
key_id = 'b6f9076e1028205bb38f33a0661627b274d0c5e02b64f8f1a9cae29d882527ab'
AND (
token = 'dD8DBBQvnQg2TQ3K292clZCAxO0OnDbVSnnApY96M/s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)