There is no parallel memory interface component in PSoC 6. We only support Serial Memory Interface (SMIF). You can find more information about this here:
If the Lattice Machxo3 SysMEM block can be modeled to look like memory interface to the PSoC, then it should work. We haven't tested with FPGAs, so I cannot guarantee anything for sure.