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())
  )

Query time 0.01468