These words are different because there is not a "blood" relationship between the 2 esposos.
For you, your sister's husband is your cuñado.
For your sister, your husband is her cuñado.
For your husband, your sister's husband is his concuñado.
For your sister's husband, your husband is also his concuñado.