Use word boundary expressions:
sed 's/\<use module_plotting\>/use module_plotting_debug/'
The zero-width patterns \< and \> will match on the boundaries of "words", i.e. between a non-word character and a word character with \< and between a word character and a non-word character with \>.
A "word character" is any alphanumeric character (possibly with taking the current locale into account, I'm uncertain about that).
My re_format(7) manual says that [[:<:]] and [[:>:]] are supposed to be more portable, but these does not seem to work with GNU sed on my system.