The song, which arrives with a visual directed by Offset, marks the second time the rappers have collaborated this year