UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8I0I0pMYJimPXZIdJSzBO50dtByLLDza9qHjdP1hmEk='
WHERE
key_id = 'eb8f67fd606189aa9cc45b30382fd8c8b30cb9e7e23ca7454dc8cfb5094dbc12'
AND (
token = '8I0I0pMYJimPXZIdJSzBO50dtByLLDza9qHjdP1hmEk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)