The kinematics in the inner kiloparsec of nearby active galaxies as revealed by molecular (ALMA) and ionized gas (Gemini-GMOS/IFU)