SELECT 
  1 
FROM 
  vi_lock_keys 
WHERE 
  key_id = '0c1eee2495e2a45e7446d3ad0298a8831fc167f1f9ef69947693573d79b21bb4' 
  AND token = 'cZx2SX2XkmoiG7sk8JvrOb5b4XR7Mwha92OMNcl6Uw4=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00009

JSON explain

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