UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xh8ZjzAh1O3aEw9rfzlOvpq3nJADlm4ZO+h2Z27X4Wk='
WHERE
key_id = '7fc9b3c84f23eacbeb14f4740a7d531abe9a07e02a9f1b4923494e26d64c9f2d'
AND (
token = 'Xh8ZjzAh1O3aEw9rfzlOvpq3nJADlm4ZO+h2Z27X4Wk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)