You'll need more than just two lights.
1. the best prime lens? You'll need a long lens with little or no rectilinear distortion. A 100mm macro might do, but a longer lens would be better. No zoom would fall into the "best" lens choice category.
2. how to WB? You will need a WB card as large as the artwork or you'll need to move the camera close to the art to fill the frame with the WB card. Either way, the WB card needs to be near the surface of the artwork. Also, anythime you are anywhere near the WB card when you do the WB you must wear only white, grey, or black clothing. Strongly colored clothing will influence the WB reading if you are just holding the card at arm's length.
Back to the lighting...
You'll want two matched lights that are both placed near 45 degrees off of the camera's line of sight. With a long copy lens, these can be somewhat closer to the camera than the classic 45 degress. These lights need to be further away from the center of the artwork than 3x the long dimension of the artwork. 5x-6x is even better.
You'll what a third light skimming the surface of the art, or nearly so, to cast the appropriate shadows to make the surface texture visible. This light needs to be dimmer that the first two, most of the time, and should be in the range of 3-4x as far away from the artwork as the main lights. Any closer an it's effect will be uneven, with a more pronounced effect on the edge closest to the light and less diagonally opposite. Also, this texture light needs to be within 45 degrees of the "top" of the artwork. In most studios, this means the art would be hung with the top to one side and the light far off to that side and somewhat above or below the center line of the artwork.
Shooting from too close, relative to the width of the artwork, will cause the viewing angle into the micro-shadows of the texture to be noticably different from one side to the other. This presents a very odd presentation that shouts "photo of painting" instead of "painting". This is why my recommendation is for a long lens. Personally I wouldn't do everything possible to use a 200mm lens at least. Under no circumstances try to make do with something in the 50-60mm range if at all possible.
The reason for the long distances to the lights is to get even lighting. As an example, if the lights are close so that the distance from the light to the center of the near edge is approximately equal to the length of that edge, the near corners will receive about 1 stop less light than the center of the edge. That's way too close as the 1 stop fall of attests to.