UPDATE 
  vi_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'wd76MIx7JgN5j8dPaG2MulUkoIqz9d1t7h1GrjPqNFE=' 
WHERE 
  key_id = '6a70eb5d4201da508e0151b3c7e3fc1349f8f5b2a7de71446e514cddcd83b51f' 
  AND (
    token = 'wd76MIx7JgN5j8dPaG2MulUkoIqz9d1t7h1GrjPqNFE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00008