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