Let $X$ be an integral variety defined over an algebraically closed field $k$ of characteristic 0 with finitely generated Picard group $Pic(X)$ and such that $k[X]^\times=k^\times$ (i.e. the only invertible global sections of the structure sheaf of $X$ are the constants).
To my knowledge, if $X$ is quasi-projective or locally factorial, then it satisfies the following property:
($*$) $Pic(X)$ is generated by effective Cartier divisors (equivalently every Cartier divisor is linearly equivalent to a difference of two effective Cartier divisors).
My question is: does there exist a variety $X$ as above that does not satisfy ($*$)?
EDIT: I recall that the group of Cartier divisors of $X$ is $\text{Div}(X)=H^0(X,\mathcal{K}(X)/\mathcal{O}^*_X)$, where $\mathcal{K}(X)$ is the constant sheaf associated to the function field of $X$ and $\mathcal{O}^*_X$ is the sheaf of units of the structure sheaf of $X$. A Cartier divisor $\{(U_i,f_i)\}_{i\in I}$ is said effective if $f_i\in H^0(U_i,\mathcal{O}_X)$ for all $i\in I$.
I have no experience with singular varieties, any reference related to this problem would be helpful.