Power a circuit with power supply and USB port, my solution
Most of this was resolved in the comments (whoops!), but I thought it's worthwhile to summarize everything.
First, is that the original solution with Q1 and Q2 won't work properly.  Let's say that J2 has 3.3V attached and is connected in the correct polarity while the USB power is also present.  +VUSB connects through D1 to +V.  Even though Q2's gate is pulled high, it will conduct through Q2's body diode.  Now, since Q1's source is a healthy voltage it is fully on due to its gate being tied low.  Re-explained better in the MSPaint masterpiece below, you have a conducting path between VUSB and J2.  There is also a similar conducting path when J2 is connected in the reverse polarity.


Therefore, a power MUX IC was recommended and I threw out the idea of TI's TPS2104/TPS2105 series.  Your modified post includes a schematic using this solution.  However, I suggest a few changes based on additional info you provided.
The TPS2104 has an active low EN, where &quot;active&quot; means IN1 is switched on instead of the default IN2.  This \$\overline{\text{EN}}\$ pin has an internal pullup according to the datasheet.  Therefore, your schematic will always have IN2 enabled since it is controlled by the +VUSB signal.  This signal is either +5-ish volts when USB is connected or high-Z if USB is disconnected.  In either case, the \$\overline{\text{EN}}\$ pin sees a logic high.
This power MUX series uses an N-channel MOSFET for IN1 and a P-channel MOSFET for IN2.  The N-channel has the benefit of lower \$R_{DS(on)}\$, while the P-channel has the benefit of lower quiescent current since its drive circuitry is simpler.  Since J2 has the possibility of being a battery in the future and your operating current (10mA) is low enough that \$R_{DS(on)}\$ on either input doesn't really matter, I suggest connecting the J2 input to IN2 instead.
Due to everything laid out above, I think you should be using the TPS2105 instead which has an active high EN pin.  Also, please add the 0.22µF capacitor on the other INx pin too.  See professionally MSPaint-ed schematic below for reference: