SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'c24f644746c4a2948f6ce3ff6402bb148a5e1ed60a9b7c7c43c8256c2777f23d' 
  AND token = 'ofD+Gd9J1ZvS5qj5sJ3kCJ8NZAfUuTGpX3N86lNDJA8=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00044

JSON explain

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