UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9wOCP4xCB9cntcILp8BYxRckbTNynSmrGJsdd4I9wpI='
WHERE
key_id = 'ddeb996071f614adb680e948aab3944860b21bd32cf1cc7c353e3e209dcf1d58'
AND (
token = '9wOCP4xCB9cntcILp8BYxRckbTNynSmrGJsdd4I9wpI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)