UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3auaJDzHnmlmwPVpl7zMRVs9I1pGJvAss8QQbllO1mc='
WHERE
key_id = '9876f771fb3718757cf5796db884847489cc39d303f101518aff6334b38a73e6'
AND (
token = '3auaJDzHnmlmwPVpl7zMRVs9I1pGJvAss8QQbllO1mc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)