UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FAfnH2qaoTB6s9VtxQ9JpxeUR3aau3tbtJZnSOK7+pc='
WHERE
key_id = '65264c0e486eaa7eb5f0161aeeaad7c7c7253eb70e3e372b6219c4c504b9f913'
AND (
token = 'FAfnH2qaoTB6s9VtxQ9JpxeUR3aau3tbtJZnSOK7+pc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)