You could look at either CY7C027 or CY7C009.
These devices have arbitration mechanism to resolve conflicts when the two hosts attempt to access the same location. You could refer to the datasheets for these devices available on our website to understand this feature.
Most applications for our Dual Port RAM's are actually like what you have explained. Two processors accessing a chip through the two ports.
Hope this helps.