SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '92977cd9e7d582db2de7d1216400f4d1ed9f55ad382527e774247609ed1a3758' 
  AND token = 'Eaq3Zg0tQ5rUW2vx0h6H8/1VmN7DtzOP6zu9OPKlHqg=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00031

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}