UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aSVigb6sBiQDw8y9VvZnVIqlDP4ltMe32DiufVADdug='
WHERE
key_id = 'df403fd9366b979fe60a1aefb6bade9cfa9dcdb73efa8460691bd863cbeb034a'
AND (
token = 'aSVigb6sBiQDw8y9VvZnVIqlDP4ltMe32DiufVADdug='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)