UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b88MkIVuzlp9TtsA6dZWQYds6WEQ0wHDqHXjoXUANHg='
WHERE
key_id = '65b05d2234dca260c0b734b9edd81069550f6aa0b230fb6ca48a11a03558ffc8'
AND (
token = 'b88MkIVuzlp9TtsA6dZWQYds6WEQ0wHDqHXjoXUANHg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)