SELECT 
  1 
FROM 
  vi_lock_keys 
WHERE 
  key_id = 'efcd270e1763b368def6a88169e9b34200a107f1b3cb506cff4c148f141426bc' 
  AND token = 'N/wJUDNknjHY0kBi9aSabLYwiqTynshVJUhPz78uwdQ=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00011

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "message": "Impossible WHERE noticed after reading const tables"
    }
  }
}