How to use sed to replace a config file’s variable?

You can try this sed:

sed -i.bak 's/^\(VAR5=\).*/\1VALUE10/' file

It gives:

VAR1=VALUE1
VAR2=VALUE2
VAR3=VALUE3
VAR4=VALUE4
VAR5=VALUE10
VAR6=VALUE6